The table.Model property in the SAS Financial Management Add-In API for the Microsoft Excel FMTable Class does not return the expected results.

When you submit Visual Basic (VBA) code to programmatically change the model that a SAS Financial Management table references, the table model does not correctly change.

For example, if your current table reads from the model 'Financial(Financial)' and you want to programmatically change the model to 'Budget(Budget)', you might submit the following VBA code to use the table.Model property in the SAS Financial Management Add-In API for the Microsoft Excel FMTable Class.

However, after you run this code, the table does not update properly. Specifically, you select Tables ► Properties and then select the Dimensions tab, the model changes to 'Financial(Budget)' instead of to 'Budget(Budget)'.

Click the Hot Fix tab in this note to access the hot fix for this issue.

For additional information about this problem, contact SAS Technical Support.

For more information about the SAS Financial Management Add-In API for Microsoft Excel, refer to the "SAS Solutions Services Customization Guide".

Note that when you are executing the code above, if you receive the compile error Error in loading DLL, you can register SASSESExcelAddin.dll as follows:

C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm.exe /codebase /tlb SASSESExcelAddin.dll

Operating System and Release Information

A fix for this issue for SAS Financial Management 5.2_M1 is available at: